{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import requests,json\n",
    "import pandas as pd\n",
    "import cufflinks as cf\n",
    "import plotly as py\n",
    "import plotly.graph_objs as go\n",
    "import io\n",
    "import base64\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "from pyecharts import options as opts\n",
    "from pyecharts.charts import Bar"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 241 entries, 0 to 240\n",
      "Data columns (total 42 columns):\n",
      " #   Column                                  Non-Null Count  Dtype \n",
      "---  ------                                  --------------  ----- \n",
      " 0   1、您的性别：                                 241 non-null    object\n",
      " 1   2、您的年龄段：                                241 non-null    object\n",
      " 2   3、您现在的居住地是：                             241 non-null    object\n",
      " 3   4、您的婚姻状况是：                              241 non-null    object\n",
      " 4   5、您的居住方式是：                              241 non-null    object\n",
      " 5   6、您的文化程度是：                              241 non-null    object\n",
      " 6   7、您现在的每个月收入（不包括子女给的）：                   241 non-null    object\n",
      " 7   8、您的子女个数：                               241 non-null    object\n",
      " 8   9、您和孩子之间的关系：                            241 non-null    object\n",
      " 9   10、您目前的身体状况：                            241 non-null    object\n",
      " 10  11、您是否经常和朋友一起进行娱乐活动                     241 non-null    object\n",
      " 11  12、您对居住地现有提供的养老服务有什么看法                  241 non-null    object\n",
      " 12  13、您是否有自己的兴趣爱好                          241 non-null    object\n",
      " 13  14、(PA您最近对生活特别满意)                       241 non-null    int64 \n",
      " 14  14、(PA您最近的情绪很好)                         241 non-null    int64 \n",
      " 15  14、(PA您最近对生活非常满意)                       241 non-null    int64 \n",
      " 16  14、(PA您最近很幸运)                           241 non-null    int64 \n",
      " 17  14、(NA您最近感到很烦恼)                         241 non-null    int64 \n",
      " 18  14、(NA您最近感觉很孤独或与人疏远)                    241 non-null    int64 \n",
      " 19  14、(NA您最近非常的忧虑或不愉快)                     241 non-null    int64 \n",
      " 20  14、(NA您最近总是很担心，因为不知道将会发生什么情况)           241 non-null    int64 \n",
      " 21  14、(NA您最近感到您的生活处境变得艰苦)                  241 non-null    int64 \n",
      " 22  14、(PA您最近的生活处境变化使你感到满意)                 241 non-null    int64 \n",
      " 23  14、(NE您感觉最近是一生中最困难的时期)                  241 non-null    int64 \n",
      " 24  14、(PE您像年轻时一样开心)                        241 non-null    int64 \n",
      " 25  14、(NE您最近所做的大部分事情都令人厌烦或单调)              241 non-null    int64 \n",
      " 26  14、(PE您最近做的事情像以前一样是您感兴趣)                241 non-null    int64 \n",
      " 27  14、(PE您回顾您的一生时，感到非常的满意)                 241 non-null    int64 \n",
      " 28  14、(NE随着年龄的增加，您感觉一切事情变得更加糟糕)            241 non-null    int64 \n",
      " 29  14、(NE您时常感到很低落)                         241 non-null    int64 \n",
      " 30  14、(NE最近您对诸事比较烦恼)                       241 non-null    int64 \n",
      " 31  14、(PE如果您有机会到想住的地方居住，您愿意离开现在的地方到那儿去居住)  241 non-null    int64 \n",
      " 32  14、(NE您有时候感觉对生活没有了希望和期待)                241 non-null    int64 \n",
      " 33  14、(PE您最近像年轻时一样高兴)                      241 non-null    int64 \n",
      " 34  14、(NE大多时候您感觉生活是艰苦的)                    241 non-null    int64 \n",
      " 35  14、(PE您对目前的生活比较满意)                      241 non-null    int64 \n",
      " 36  14、(PE您的身体状况比同龄人差不多甚至好于他人)              241 non-null    int64 \n",
      " 37  总分                                      241 non-null    int64 \n",
      " 38  PA总分                                    241 non-null    int64 \n",
      " 39  NA总分                                    241 non-null    int64 \n",
      " 40  PE总分                                    241 non-null    int64 \n",
      " 41  NE总分                                    241 non-null    int64 \n",
      "dtypes: int64(29), object(13)\n",
      "memory usage: 79.2+ KB\n"
     ]
    }
   ],
   "source": [
    "df = pd.read_excel(\"幸福感分析.xlsx\", encoding = \"utf8\", sep=\"\\t\")\n",
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>1、您的性别：</th>\n",
       "      <th>2、您的年龄段：</th>\n",
       "      <th>3、您现在的居住地是：</th>\n",
       "      <th>4、您的婚姻状况是：</th>\n",
       "      <th>5、您的居住方式是：</th>\n",
       "      <th>6、您的文化程度是：</th>\n",
       "      <th>7、您现在的每个月收入（不包括子女给的）：</th>\n",
       "      <th>8、您的子女个数：</th>\n",
       "      <th>9、您和孩子之间的关系：</th>\n",
       "      <th>10、您目前的身体状况：</th>\n",
       "      <th>...</th>\n",
       "      <th>14、(NE您有时候感觉对生活没有了希望和期待)</th>\n",
       "      <th>14、(PE您最近像年轻时一样高兴)</th>\n",
       "      <th>14、(NE大多时候您感觉生活是艰苦的)</th>\n",
       "      <th>14、(PE您对目前的生活比较满意)</th>\n",
       "      <th>14、(PE您的身体状况比同龄人差不多甚至好于他人)</th>\n",
       "      <th>总分</th>\n",
       "      <th>PA总分</th>\n",
       "      <th>NA总分</th>\n",
       "      <th>PE总分</th>\n",
       "      <th>NE总分</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>男</td>\n",
       "      <td>80岁以上</td>\n",
       "      <td>西北地区（陕西省、甘肃省、青海省、宁夏回族自治区、新疆维吾尔自治区）</td>\n",
       "      <td>未结过婚</td>\n",
       "      <td>独自一个人居住</td>\n",
       "      <td>文盲</td>\n",
       "      <td>1000元以下</td>\n",
       "      <td>没有孩子</td>\n",
       "      <td>关系较差</td>\n",
       "      <td>身体不好</td>\n",
       "      <td>...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>24</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>女</td>\n",
       "      <td>60-69岁</td>\n",
       "      <td>华东地区（上海市、江苏省、浙江省、安徽省、福建省、江西省、山东省、台湾省）</td>\n",
       "      <td>离婚</td>\n",
       "      <td>独自一个人居住</td>\n",
       "      <td>大专或者本科</td>\n",
       "      <td>5500-7000元</td>\n",
       "      <td>1个</td>\n",
       "      <td>很亲近</td>\n",
       "      <td>非常健康</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>42</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>女</td>\n",
       "      <td>60-69岁</td>\n",
       "      <td>西南地区（四川省、贵州省、云南省、重庆市、西藏自治区）</td>\n",
       "      <td>丧偶</td>\n",
       "      <td>独自一个人居住</td>\n",
       "      <td>文盲</td>\n",
       "      <td>1000元以下</td>\n",
       "      <td>2个</td>\n",
       "      <td>关系一般</td>\n",
       "      <td>身体不好</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>男</td>\n",
       "      <td>60-69岁</td>\n",
       "      <td>东北地区（黑龙江省、吉林省、辽宁省）</td>\n",
       "      <td>丧偶</td>\n",
       "      <td>独自一个人居住</td>\n",
       "      <td>文盲</td>\n",
       "      <td>1000-2500元</td>\n",
       "      <td>2个</td>\n",
       "      <td>关系较差</td>\n",
       "      <td>身体不好</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>女</td>\n",
       "      <td>70-79岁</td>\n",
       "      <td>华东地区（上海市、江苏省、浙江省、安徽省、福建省、江西省、山东省、台湾省）</td>\n",
       "      <td>已婚</td>\n",
       "      <td>和配偶居住在一起</td>\n",
       "      <td>大专或者本科</td>\n",
       "      <td>1000-2500元</td>\n",
       "      <td>1个</td>\n",
       "      <td>比较亲近</td>\n",
       "      <td>非常健康</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>28</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  1、您的性别： 2、您的年龄段：                            3、您现在的居住地是： 4、您的婚姻状况是：  \\\n",
       "0       男    80岁以上     西北地区（陕西省、甘肃省、青海省、宁夏回族自治区、新疆维吾尔自治区）       未结过婚   \n",
       "1       女   60-69岁  华东地区（上海市、江苏省、浙江省、安徽省、福建省、江西省、山东省、台湾省）         离婚   \n",
       "2       女   60-69岁            西南地区（四川省、贵州省、云南省、重庆市、西藏自治区）         丧偶   \n",
       "3       男   60-69岁                     东北地区（黑龙江省、吉林省、辽宁省）         丧偶   \n",
       "4       女   70-79岁  华东地区（上海市、江苏省、浙江省、安徽省、福建省、江西省、山东省、台湾省）         已婚   \n",
       "\n",
       "  5、您的居住方式是： 6、您的文化程度是： 7、您现在的每个月收入（不包括子女给的）： 8、您的子女个数： 9、您和孩子之间的关系：  \\\n",
       "0    独自一个人居住         文盲               1000元以下      没有孩子         关系较差   \n",
       "1    独自一个人居住     大专或者本科            5500-7000元        1个          很亲近   \n",
       "2    独自一个人居住         文盲               1000元以下        2个         关系一般   \n",
       "3    独自一个人居住         文盲            1000-2500元        2个         关系较差   \n",
       "4   和配偶居住在一起     大专或者本科            1000-2500元        1个         比较亲近   \n",
       "\n",
       "  10、您目前的身体状况：  ... 14、(NE您有时候感觉对生活没有了希望和期待) 14、(PE您最近像年轻时一样高兴)  \\\n",
       "0         身体不好  ...                        2                  2   \n",
       "1         非常健康  ...                        0                  2   \n",
       "2         身体不好  ...                        0                  0   \n",
       "3         身体不好  ...                        1                  2   \n",
       "4         非常健康  ...                        1                  1   \n",
       "\n",
       "  14、(NE大多时候您感觉生活是艰苦的)  14、(PE您对目前的生活比较满意)  14、(PE您的身体状况比同龄人差不多甚至好于他人)  总分  \\\n",
       "0                    2                   2                           2  24   \n",
       "1                    0                   2                           2  42   \n",
       "2                    2                   2                           0  19   \n",
       "3                    2                   1                           1  23   \n",
       "4                    2                   1                           2  28   \n",
       "\n",
       "   PA总分  NA总分  PE总分  NE总分  \n",
       "0    10    10    14    14  \n",
       "1    10     0    12     4  \n",
       "2     1     6     5     5  \n",
       "3     5     5     8     9  \n",
       "4     7     2    10    11  \n",
       "\n",
       "[5 rows x 42 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th colspan=\"3\" halign=\"left\">总分</th>\n",
       "      <th colspan=\"3\" halign=\"left\">PA总分</th>\n",
       "      <th colspan=\"3\" halign=\"left\">NA总分</th>\n",
       "      <th colspan=\"3\" halign=\"left\">PE总分</th>\n",
       "      <th colspan=\"3\" halign=\"left\">NE总分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th>均值</th>\n",
       "      <th>最大</th>\n",
       "      <th>最小</th>\n",
       "      <th>均值</th>\n",
       "      <th>最大</th>\n",
       "      <th>最小</th>\n",
       "      <th>均值</th>\n",
       "      <th>最大</th>\n",
       "      <th>最小</th>\n",
       "      <th>均值</th>\n",
       "      <th>最大</th>\n",
       "      <th>最小</th>\n",
       "      <th>均值</th>\n",
       "      <th>最大</th>\n",
       "      <th>最小</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1、您的性别：</th>\n",
       "      <th>2、您的年龄段：</th>\n",
       "      <th>6、您的文化程度是：</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"21\" valign=\"top\">女</th>\n",
       "      <th rowspan=\"7\" valign=\"top\">60-69岁</th>\n",
       "      <th>中专或技校</th>\n",
       "      <td>23.000000</td>\n",
       "      <td>26</td>\n",
       "      <td>20</td>\n",
       "      <td>5.333333</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>5.333333</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>初中</th>\n",
       "      <td>21.750000</td>\n",
       "      <td>27</td>\n",
       "      <td>19</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>6.250000</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>7.250000</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>大专或者本科</th>\n",
       "      <td>29.666667</td>\n",
       "      <td>42</td>\n",
       "      <td>23</td>\n",
       "      <td>9.333333</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "      <td>8.666667</td>\n",
       "      <td>14</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小学</th>\n",
       "      <td>26.125000</td>\n",
       "      <td>44</td>\n",
       "      <td>19</td>\n",
       "      <td>4.750000</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>4.250000</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>7.875000</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>6.250000</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>文盲</th>\n",
       "      <td>22.600000</td>\n",
       "      <td>28</td>\n",
       "      <td>18</td>\n",
       "      <td>5.200000</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>4.900000</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>4.600000</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>6.300000</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>硕士研究生及以上学历</th>\n",
       "      <td>24.000000</td>\n",
       "      <td>29</td>\n",
       "      <td>19</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>7.400000</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "      <td>7.400000</td>\n",
       "      <td>11</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高中</th>\n",
       "      <td>28.333333</td>\n",
       "      <td>45</td>\n",
       "      <td>18</td>\n",
       "      <td>5.666667</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">70-79岁</th>\n",
       "      <th>中专或技校</th>\n",
       "      <td>29.000000</td>\n",
       "      <td>40</td>\n",
       "      <td>23</td>\n",
       "      <td>6.333333</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>9</td>\n",
       "      <td>7</td>\n",
       "      <td>5.833333</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>初中</th>\n",
       "      <td>22.666667</td>\n",
       "      <td>26</td>\n",
       "      <td>19</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>5.333333</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>6.666667</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>8.666667</td>\n",
       "      <td>11</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>大专或者本科</th>\n",
       "      <td>25.500000</td>\n",
       "      <td>28</td>\n",
       "      <td>23</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>9.500000</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>9.500000</td>\n",
       "      <td>11</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小学</th>\n",
       "      <td>28.000000</td>\n",
       "      <td>44</td>\n",
       "      <td>19</td>\n",
       "      <td>5.600000</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>8.400000</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>5.600000</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>文盲</th>\n",
       "      <td>28.571429</td>\n",
       "      <td>48</td>\n",
       "      <td>22</td>\n",
       "      <td>5.571429</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>5.857143</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>4.857143</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>硕士研究生及以上学历</th>\n",
       "      <td>22.500000</td>\n",
       "      <td>28</td>\n",
       "      <td>19</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>4.250000</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>8.750000</td>\n",
       "      <td>11</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高中</th>\n",
       "      <td>25.125000</td>\n",
       "      <td>30</td>\n",
       "      <td>17</td>\n",
       "      <td>5.125000</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>4.875000</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>7.250000</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>6.375000</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">80岁以上</th>\n",
       "      <th>中专或技校</th>\n",
       "      <td>22.571429</td>\n",
       "      <td>28</td>\n",
       "      <td>19</td>\n",
       "      <td>5.428571</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>5.857143</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>初中</th>\n",
       "      <td>25.533333</td>\n",
       "      <td>37</td>\n",
       "      <td>16</td>\n",
       "      <td>5.666667</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>4.200000</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>7.200000</td>\n",
       "      <td>11</td>\n",
       "      <td>4</td>\n",
       "      <td>7.133333</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>大专或者本科</th>\n",
       "      <td>21.000000</td>\n",
       "      <td>22</td>\n",
       "      <td>20</td>\n",
       "      <td>2.500000</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>6.500000</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小学</th>\n",
       "      <td>25.250000</td>\n",
       "      <td>29</td>\n",
       "      <td>21</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>5.750000</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>11</td>\n",
       "      <td>4</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>文盲</th>\n",
       "      <td>26.500000</td>\n",
       "      <td>41</td>\n",
       "      <td>19</td>\n",
       "      <td>5.800000</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>4.900000</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>7.200000</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>5.600000</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>硕士研究生及以上学历</th>\n",
       "      <td>22.666667</td>\n",
       "      <td>30</td>\n",
       "      <td>16</td>\n",
       "      <td>3.666667</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>7.500000</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>8.166667</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高中</th>\n",
       "      <td>27.000000</td>\n",
       "      <td>30</td>\n",
       "      <td>24</td>\n",
       "      <td>5.600000</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>4.800000</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>8.800000</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>6.600000</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"21\" valign=\"top\">男</th>\n",
       "      <th rowspan=\"7\" valign=\"top\">60-69岁</th>\n",
       "      <th>中专或技校</th>\n",
       "      <td>21.000000</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>初中</th>\n",
       "      <td>20.714286</td>\n",
       "      <td>28</td>\n",
       "      <td>16</td>\n",
       "      <td>3.857143</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>6.714286</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>7.857143</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>大专或者本科</th>\n",
       "      <td>33.400000</td>\n",
       "      <td>48</td>\n",
       "      <td>24</td>\n",
       "      <td>6.200000</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>2.800000</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>9.400000</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>3.400000</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小学</th>\n",
       "      <td>22.416667</td>\n",
       "      <td>27</td>\n",
       "      <td>18</td>\n",
       "      <td>4.916667</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>6.583333</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>7.833333</td>\n",
       "      <td>11</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>文盲</th>\n",
       "      <td>23.666667</td>\n",
       "      <td>26</td>\n",
       "      <td>19</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>6.500000</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>6.833333</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>硕士研究生及以上学历</th>\n",
       "      <td>23.000000</td>\n",
       "      <td>27</td>\n",
       "      <td>18</td>\n",
       "      <td>4.750000</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>6.250000</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>7.750000</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>7.250000</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高中</th>\n",
       "      <td>25.000000</td>\n",
       "      <td>30</td>\n",
       "      <td>19</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>4.750000</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>6.500000</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">70-79岁</th>\n",
       "      <th>中专或技校</th>\n",
       "      <td>23.375000</td>\n",
       "      <td>29</td>\n",
       "      <td>20</td>\n",
       "      <td>4.375000</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>7.875000</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "      <td>7.375000</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>初中</th>\n",
       "      <td>20.666667</td>\n",
       "      <td>23</td>\n",
       "      <td>18</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>6.666667</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "      <td>8.666667</td>\n",
       "      <td>10</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>大专或者本科</th>\n",
       "      <td>18.000000</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小学</th>\n",
       "      <td>26.090909</td>\n",
       "      <td>39</td>\n",
       "      <td>19</td>\n",
       "      <td>5.090909</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>4.636364</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>8.636364</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>文盲</th>\n",
       "      <td>23.428571</td>\n",
       "      <td>27</td>\n",
       "      <td>18</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>4.428571</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>5.142857</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>5.285714</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>硕士研究生及以上学历</th>\n",
       "      <td>26.000000</td>\n",
       "      <td>30</td>\n",
       "      <td>21</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>7.500000</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高中</th>\n",
       "      <td>19.500000</td>\n",
       "      <td>23</td>\n",
       "      <td>16</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>12</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"7\" valign=\"top\">80岁以上</th>\n",
       "      <th>中专或技校</th>\n",
       "      <td>22.666667</td>\n",
       "      <td>30</td>\n",
       "      <td>18</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>5.666667</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>6.500000</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>6.833333</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>初中</th>\n",
       "      <td>24.500000</td>\n",
       "      <td>31</td>\n",
       "      <td>20</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>5.250000</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>6.750000</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>6.250000</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>大专或者本科</th>\n",
       "      <td>33.666667</td>\n",
       "      <td>44</td>\n",
       "      <td>20</td>\n",
       "      <td>7.333333</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>9.666667</td>\n",
       "      <td>14</td>\n",
       "      <td>3</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小学</th>\n",
       "      <td>26.454545</td>\n",
       "      <td>46</td>\n",
       "      <td>20</td>\n",
       "      <td>6.727273</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "      <td>4.636364</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>7.545455</td>\n",
       "      <td>12</td>\n",
       "      <td>3</td>\n",
       "      <td>7.181818</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>文盲</th>\n",
       "      <td>24.000000</td>\n",
       "      <td>32</td>\n",
       "      <td>16</td>\n",
       "      <td>6.111111</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>6.444444</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>8.222222</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>硕士研究生及以上学历</th>\n",
       "      <td>25.250000</td>\n",
       "      <td>32</td>\n",
       "      <td>19</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>3.750000</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>5.750000</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>6.750000</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高中</th>\n",
       "      <td>25.500000</td>\n",
       "      <td>31</td>\n",
       "      <td>22</td>\n",
       "      <td>4.750000</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>3.500000</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>7.750000</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>7.500000</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    总分              PA总分             NA总分      \\\n",
       "                                    均值  最大  最小        均值  最大 最小        均值  最大   \n",
       "1、您的性别： 2、您的年龄段： 6、您的文化程度是：                                                     \n",
       "女       60-69岁   中专或技校       23.000000  26  20  5.333333   6  5  5.333333   8   \n",
       "                 初中          21.750000  27  19  5.250000   8  2  6.250000   9   \n",
       "                 大专或者本科      29.666667  42  23  9.333333  10  8  6.000000  10   \n",
       "                 小学          26.125000  44  19  4.750000   9  2  4.250000   6   \n",
       "                 文盲          22.600000  28  18  5.200000   9  1  4.900000   8   \n",
       "                 硕士研究生及以上学历  24.000000  29  19  5.000000   6  4  5.000000   6   \n",
       "                 高中          28.333333  45  18  5.666667  10  3  4.000000   7   \n",
       "        70-79岁   中专或技校       29.000000  40  23  6.333333   9  3  3.500000   5   \n",
       "                 初中          22.666667  26  19  6.000000   8  4  5.333333   8   \n",
       "                 大专或者本科      25.500000  28  23  5.500000   7  4  4.000000   6   \n",
       "                 小学          28.000000  44  19  5.600000  10  2  4.400000   7   \n",
       "                 文盲          28.571429  48  22  5.571429  10  4  2.000000   6   \n",
       "                 硕士研究生及以上学历  22.500000  28  19  6.000000   9  4  4.250000   6   \n",
       "                 高中          25.125000  30  17  5.125000   9  2  4.875000   7   \n",
       "        80岁以上    中专或技校       22.571429  28  19  5.428571   8  4  5.857143   7   \n",
       "                 初中          25.533333  37  16  5.666667  10  3  4.200000   7   \n",
       "                 大专或者本科      21.000000  22  20  2.500000   4  1  6.500000   8   \n",
       "                 小学          25.250000  29  21  4.500000   6  4  5.750000   7   \n",
       "                 文盲          26.500000  41  19  5.800000  10  2  4.900000   8   \n",
       "                 硕士研究生及以上学历  22.666667  30  16  3.666667   6  1  4.333333   8   \n",
       "                 高中          27.000000  30  24  5.600000   7  4  4.800000   8   \n",
       "男       60-69岁   中专或技校       21.000000  21  21  3.000000   3  3  4.000000   4   \n",
       "                 初中          20.714286  28  16  3.857143   5  2  6.000000   8   \n",
       "                 大专或者本科      33.400000  48  24  6.200000  10  3  2.800000   7   \n",
       "                 小学          22.416667  27  18  4.916667   8  1  5.250000   8   \n",
       "                 文盲          23.666667  26  19  4.666667   7  2  4.666667   5   \n",
       "                 硕士研究生及以上学历  23.000000  27  18  4.750000   7  3  6.250000   8   \n",
       "                 高中          25.000000  30  19  4.500000   7  2  4.750000   6   \n",
       "        70-79岁   中专或技校       23.375000  29  20  4.375000   7  1  5.500000   8   \n",
       "                 初中          20.666667  23  18  3.000000   4  1  4.333333   5   \n",
       "                 大专或者本科      18.000000  18  18  3.000000   3  3  6.000000   6   \n",
       "                 小学          26.090909  39  19  5.090909  10  2  4.636364  10   \n",
       "                 文盲          23.428571  27  18  4.000000   8  0  4.428571   7   \n",
       "                 硕士研究生及以上学历  26.000000  30  21  4.500000   7  2  4.500000   7   \n",
       "                 高中          19.500000  23  16  3.500000   4  3  4.000000   5   \n",
       "        80岁以上    中专或技校       22.666667  30  18  4.666667   7  3  5.666667   7   \n",
       "                 初中          24.500000  31  20  5.250000   6  4  5.250000   8   \n",
       "                 大专或者本科      33.666667  44  20  7.333333   9  5  3.000000   5   \n",
       "                 小学          26.454545  46  20  6.727273  10  4  4.636364  10   \n",
       "                 文盲          24.000000  32  16  6.111111  10  3  4.333333  10   \n",
       "                 硕士研究生及以上学历  25.250000  32  19  6.000000   9  3  3.750000   5   \n",
       "                 高中          25.500000  31  22  4.750000   6  4  3.500000   6   \n",
       "\n",
       "                                     PE总分              NE总分         \n",
       "                            最小         均值  最大 最小         均值  最大 最小  \n",
       "1、您的性别： 2、您的年龄段： 6、您的文化程度是：                                         \n",
       "女       60-69岁   中专或技校       4   6.000000   8  3   7.000000   8  5  \n",
       "                 初中          4   6.000000   7  4   7.250000   8  5  \n",
       "                 大专或者本科      0  11.000000  14  7   8.666667  14  4  \n",
       "                 小学          0   7.875000  12  5   6.250000  11  1  \n",
       "                 文盲          2   4.600000   7  3   6.300000   9  3  \n",
       "                 硕士研究生及以上学历  4   7.400000  11  5   7.400000  11  6  \n",
       "                 高中          0   7.000000  11  5   4.333333   8  0  \n",
       "        70-79岁   中专或技校       1   8.000000   9  7   5.833333  10  1  \n",
       "                 初中          2   6.666667   8  5   8.666667  11  7  \n",
       "                 大专或者本科      2   9.500000  10  9   9.500000  11  8  \n",
       "                 小学          0   8.400000  12  5   5.600000  11  0  \n",
       "                 文盲          0   5.857143  14  2   4.857143   9  0  \n",
       "                 硕士研究生及以上学历  2   5.500000   7  3   8.750000  11  7  \n",
       "                 高中          1   7.250000  10  6   6.375000   9  4  \n",
       "        80岁以上    中专或技校       5   6.000000   9  3   7.000000   9  5  \n",
       "                 初中          0   7.200000  11  4   7.133333  12  2  \n",
       "                 大专或者本科      5   7.000000   7  7   6.000000   8  4  \n",
       "                 小学          4   8.000000  11  4   5.500000   7  4  \n",
       "                 文盲          3   7.200000  10  5   5.600000  11  0  \n",
       "                 硕士研究生及以上学历  3   7.500000  10  4   8.166667  12  4  \n",
       "                 高中          2   8.800000  10  7   6.600000  10  4  \n",
       "男       60-69岁   中专或技校       4   6.000000   6  6   8.000000   8  8  \n",
       "                 初中          3   6.714286  12  3   7.857143  12  4  \n",
       "                 大专或者本科      0   9.400000  14  5   3.400000   5  0  \n",
       "                 小学          2   6.583333   9  3   7.833333  11  6  \n",
       "                 文盲          4   6.500000   8  3   6.833333   9  4  \n",
       "                 硕士研究生及以上学历  4   7.750000  10  3   7.250000   9  5  \n",
       "                 高中          3   6.500000   9  5   5.250000   8  2  \n",
       "        70-79岁   中专或技校       3   7.875000  11  5   7.375000  10  5  \n",
       "                 初中          3   6.666667   8  5   8.666667  10  8  \n",
       "                 大专或者本科      6   5.000000   5  5   8.000000   8  8  \n",
       "                 小学          1   8.636364  14  5   7.000000  14  3  \n",
       "                 文盲          0   5.142857   9  0   5.285714   9  0  \n",
       "                 硕士研究生及以上学历  3   7.500000  10  5   5.500000   8  4  \n",
       "                 高中          3   6.000000   8  4  10.000000  12  8  \n",
       "        80岁以上    中专或技校       4   6.500000   9  4   6.833333  10  4  \n",
       "                 初中          3   6.750000  10  3   6.250000   9  3  \n",
       "                 大专或者本科      0   9.666667  14  3   4.333333   7  0  \n",
       "                 小学          0   7.545455  12  3   7.181818  11  0  \n",
       "                 文盲          0   6.444444  14  2   8.222222  14  2  \n",
       "                 硕士研究生及以上学历  1   5.750000   8  3   6.750000   9  5  \n",
       "                 高中          2   7.750000  10  5   7.500000  10  3  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "性别与文化 = df.groupby ( by = ['1、您的性别：','2、您的年龄段：','6、您的文化程度是：'] ) \\\n",
    "             .agg ({ \"总分\" : [\"mean\",\"max\",\"min\"], \\\n",
    "                     \"PA总分\":[\"mean\",\"max\",\"min\"], \\\n",
    "                     \"NA总分\":[\"mean\",\"max\",\"min\"], \\\n",
    "                     \"PE总分\":[\"mean\",\"max\",\"min\"], \\\n",
    "                     \"NE总分\":[\"mean\",\"max\",\"min\"],}) \\\n",
    "             .rename ( columns = {\"mean\":\"均值\",\"max\":\"最大\", \"min\":\"最小\"} )\n",
    "display(性别与文化)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "性别 = df.groupby ( by = ['1、您的性别：'] ) \\\n",
    "             .agg ({ \"总分\" : [\"mean\"], \\\n",
    "                     \"PA总分\":[\"mean\"], \\\n",
    "                     \"NA总分\":[\"mean\"], \\\n",
    "                     \"PE总分\":[\"mean\"], \\\n",
    "                     \"NE总分\":[\"mean\"],}) \\\n",
    "             .rename ( columns = {\"mean\":\"均值\"} )\n",
    "年龄 = df.groupby ( by = ['2、您的年龄段：'] ) \\\n",
    "             .agg ({ \"总分\" : [\"mean\"], \\\n",
    "                     \"PA总分\":[\"mean\"], \\\n",
    "                     \"NA总分\":[\"mean\"], \\\n",
    "                     \"PE总分\":[\"mean\"], \\\n",
    "                     \"NE总分\":[\"mean\"],}) \\\n",
    "             .rename ( columns = {\"mean\":\"均值\"} )\n",
    "居住地 = df.groupby ( by = ['3、您现在的居住地是：'] ) \\\n",
    "             .agg ({ \"总分\" : [\"mean\"], \\\n",
    "                     \"PA总分\":[\"mean\"], \\\n",
    "                     \"NA总分\":[\"mean\"], \\\n",
    "                     \"PE总分\":[\"mean\"], \\\n",
    "                     \"NE总分\":[\"mean\"],}) \\\n",
    "             .rename ( columns = {\"mean\":\"均值\"} )\n",
    "婚姻 = df.groupby ( by = ['4、您的婚姻状况是：'] ) \\\n",
    "             .agg ({ \"总分\" : [\"mean\"], \\\n",
    "                     \"PA总分\":[\"mean\"], \\\n",
    "                     \"NA总分\":[\"mean\"], \\\n",
    "                     \"PE总分\":[\"mean\"], \\\n",
    "                     \"NE总分\":[\"mean\"],}) \\\n",
    "             .rename ( columns = {\"mean\":\"均值\"} )\n",
    "居住方式 = df.groupby ( by = ['5、您的居住方式是：'] ) \\\n",
    "             .agg ({ \"总分\" : [\"mean\"], \\\n",
    "                     \"PA总分\":[\"mean\"], \\\n",
    "                     \"NA总分\":[\"mean\"], \\\n",
    "                     \"PE总分\":[\"mean\"], \\\n",
    "                     \"NE总分\":[\"mean\"],}) \\\n",
    "             .rename ( columns = {\"mean\":\"均值\"} )\n",
    "文化 = df.groupby ( by = ['6、您的文化程度是：'] ) \\\n",
    "             .agg ({ \"总分\" : [\"mean\"], \\\n",
    "                     \"PA总分\":[\"mean\"], \\\n",
    "                     \"NA总分\":[\"mean\"], \\\n",
    "                     \"PE总分\":[\"mean\"], \\\n",
    "                     \"NE总分\":[\"mean\"],}) \\\n",
    "             .rename ( columns = {\"mean\":\"均值\"} )\n",
    "收入 = df.groupby ( by = ['7、您现在的每个月收入（不包括子女给的）：'] ) \\\n",
    "             .agg ({ \"总分\" : [\"mean\"], \\\n",
    "                     \"PA总分\":[\"mean\"], \\\n",
    "                     \"NA总分\":[\"mean\"], \\\n",
    "                     \"PE总分\":[\"mean\"], \\\n",
    "                     \"NE总分\":[\"mean\"],}) \\\n",
    "             .rename ( columns = {\"mean\":\"均值\"} )\n",
    "子女关系 = df.groupby ( by = ['9、您和孩子之间的关系：'] ) \\\n",
    "             .agg ({ \"总分\" : [\"mean\"], \\\n",
    "                     \"PA总分\":[\"mean\"], \\\n",
    "                     \"NA总分\":[\"mean\"], \\\n",
    "                     \"PE总分\":[\"mean\"], \\\n",
    "                     \"NE总分\":[\"mean\"],}) \\\n",
    "             .rename ( columns = {\"mean\":\"均值\"} )\n",
    "身体 = df.groupby ( by = ['10、您目前的身体状况：'] ) \\\n",
    "             .agg ({ \"总分\" : [\"mean\"], \\\n",
    "                     \"PA总分\":[\"mean\"], \\\n",
    "                     \"NA总分\":[\"mean\"], \\\n",
    "                     \"PE总分\":[\"mean\"], \\\n",
    "                     \"NE总分\":[\"mean\"],}) \\\n",
    "             .rename ( columns = {\"mean\":\"均值\"} )\n",
    "娱乐 = df.groupby ( by = ['11、您是否经常和朋友一起进行娱乐活动'] ) \\\n",
    "             .agg ({ \"总分\" : [\"mean\"], \\\n",
    "                     \"PA总分\":[\"mean\"], \\\n",
    "                     \"NA总分\":[\"mean\"], \\\n",
    "                     \"PE总分\":[\"mean\"], \\\n",
    "                     \"NE总分\":[\"mean\"],}) \\\n",
    "             .rename ( columns = {\"mean\":\"均值\"} )\n",
    "兴趣 = df.groupby ( by = ['13、您是否有自己的兴趣爱好'] ) \\\n",
    "             .agg ({ \"总分\" : [\"mean\"], \\\n",
    "                     \"PA总分\":[\"mean\"], \\\n",
    "                     \"NA总分\":[\"mean\"], \\\n",
    "                     \"PE总分\":[\"mean\"], \\\n",
    "                     \"NE总分\":[\"mean\"],}) \\\n",
    "             .rename ( columns = {\"mean\":\"均值\"} )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>总分</th>\n",
       "      <th>PA总分</th>\n",
       "      <th>NA总分</th>\n",
       "      <th>PE总分</th>\n",
       "      <th>NE总分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1、您的性别：</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>女</th>\n",
       "      <td>25.352</td>\n",
       "      <td>5.424000</td>\n",
       "      <td>4.616000</td>\n",
       "      <td>7.12800</td>\n",
       "      <td>6.584000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>男</th>\n",
       "      <td>24.500</td>\n",
       "      <td>5.034483</td>\n",
       "      <td>4.732759</td>\n",
       "      <td>7.12069</td>\n",
       "      <td>6.922414</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             总分      PA总分      NA总分     PE总分      NE总分\n",
       "             均值        均值        均值       均值        均值\n",
       "1、您的性别：                                               \n",
       "女        25.352  5.424000  4.616000  7.12800  6.584000\n",
       "男        24.500  5.034483  4.732759  7.12069  6.922414"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>总分</th>\n",
       "      <th>PA总分</th>\n",
       "      <th>NA总分</th>\n",
       "      <th>PE总分</th>\n",
       "      <th>NE总分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2、您的年龄段：</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>60-69岁</th>\n",
       "      <td>24.280000</td>\n",
       "      <td>5.093333</td>\n",
       "      <td>4.986667</td>\n",
       "      <td>6.893333</td>\n",
       "      <td>6.720000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70-79岁</th>\n",
       "      <td>25.328947</td>\n",
       "      <td>5.039474</td>\n",
       "      <td>4.342105</td>\n",
       "      <td>7.276316</td>\n",
       "      <td>6.644737</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80岁以上</th>\n",
       "      <td>25.166667</td>\n",
       "      <td>5.522222</td>\n",
       "      <td>4.688889</td>\n",
       "      <td>7.188889</td>\n",
       "      <td>6.855556</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 总分      PA总分      NA总分      PE总分      NE总分\n",
       "                 均值        均值        均值        均值        均值\n",
       "2、您的年龄段：                                                   \n",
       "60-69岁    24.280000  5.093333  4.986667  6.893333  6.720000\n",
       "70-79岁    25.328947  5.039474  4.342105  7.276316  6.644737\n",
       "80岁以上     25.166667  5.522222  4.688889  7.188889  6.855556"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>总分</th>\n",
       "      <th>PA总分</th>\n",
       "      <th>NA总分</th>\n",
       "      <th>PE总分</th>\n",
       "      <th>NE总分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3、您现在的居住地是：</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>东北地区（黑龙江省、吉林省、辽宁省）</th>\n",
       "      <td>23.595238</td>\n",
       "      <td>4.785714</td>\n",
       "      <td>4.952381</td>\n",
       "      <td>7.285714</td>\n",
       "      <td>7.523810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华东地区（上海市、江苏省、浙江省、安徽省、福建省、江西省、山东省、台湾省）</th>\n",
       "      <td>26.030303</td>\n",
       "      <td>5.530303</td>\n",
       "      <td>3.969697</td>\n",
       "      <td>6.893939</td>\n",
       "      <td>6.424242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华中地区（河南省、湖北省、湖南省）</th>\n",
       "      <td>26.588235</td>\n",
       "      <td>5.235294</td>\n",
       "      <td>4.352941</td>\n",
       "      <td>6.941176</td>\n",
       "      <td>5.235294</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华北地区（北京市、天津市、山西省、河北省、内蒙古自治区）</th>\n",
       "      <td>24.527273</td>\n",
       "      <td>4.927273</td>\n",
       "      <td>5.018182</td>\n",
       "      <td>7.327273</td>\n",
       "      <td>6.709091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>华南地区（广东省、广西壮族自治区、海南省、香港特别行政区、澳门特别行政区）</th>\n",
       "      <td>25.434783</td>\n",
       "      <td>5.478261</td>\n",
       "      <td>4.956522</td>\n",
       "      <td>7.565217</td>\n",
       "      <td>6.652174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>西北地区（陕西省、甘肃省、青海省、宁夏回族自治区、新疆维吾尔自治区）</th>\n",
       "      <td>24.238095</td>\n",
       "      <td>5.857143</td>\n",
       "      <td>5.047619</td>\n",
       "      <td>6.809524</td>\n",
       "      <td>7.380952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>西南地区（四川省、贵州省、云南省、重庆市、西藏自治区）</th>\n",
       "      <td>23.941176</td>\n",
       "      <td>5.117647</td>\n",
       "      <td>5.058824</td>\n",
       "      <td>6.941176</td>\n",
       "      <td>7.058824</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              总分      PA总分      NA总分  \\\n",
       "                                              均值        均值        均值   \n",
       "3、您现在的居住地是：                                                            \n",
       "东北地区（黑龙江省、吉林省、辽宁省）                     23.595238  4.785714  4.952381   \n",
       "华东地区（上海市、江苏省、浙江省、安徽省、福建省、江西省、山东省、台湾省）  26.030303  5.530303  3.969697   \n",
       "华中地区（河南省、湖北省、湖南省）                      26.588235  5.235294  4.352941   \n",
       "华北地区（北京市、天津市、山西省、河北省、内蒙古自治区）           24.527273  4.927273  5.018182   \n",
       "华南地区（广东省、广西壮族自治区、海南省、香港特别行政区、澳门特别行政区）  25.434783  5.478261  4.956522   \n",
       "西北地区（陕西省、甘肃省、青海省、宁夏回族自治区、新疆维吾尔自治区）     24.238095  5.857143  5.047619   \n",
       "西南地区（四川省、贵州省、云南省、重庆市、西藏自治区）            23.941176  5.117647  5.058824   \n",
       "\n",
       "                                           PE总分      NE总分  \n",
       "                                             均值        均值  \n",
       "3、您现在的居住地是：                                                \n",
       "东北地区（黑龙江省、吉林省、辽宁省）                     7.285714  7.523810  \n",
       "华东地区（上海市、江苏省、浙江省、安徽省、福建省、江西省、山东省、台湾省）  6.893939  6.424242  \n",
       "华中地区（河南省、湖北省、湖南省）                      6.941176  5.235294  \n",
       "华北地区（北京市、天津市、山西省、河北省、内蒙古自治区）           7.327273  6.709091  \n",
       "华南地区（广东省、广西壮族自治区、海南省、香港特别行政区、澳门特别行政区）  7.565217  6.652174  \n",
       "西北地区（陕西省、甘肃省、青海省、宁夏回族自治区、新疆维吾尔自治区）     6.809524  7.380952  \n",
       "西南地区（四川省、贵州省、云南省、重庆市、西藏自治区）            6.941176  7.058824  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>总分</th>\n",
       "      <th>PA总分</th>\n",
       "      <th>NA总分</th>\n",
       "      <th>PE总分</th>\n",
       "      <th>NE总分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4、您的婚姻状况是：</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>丧偶</th>\n",
       "      <td>28.040000</td>\n",
       "      <td>6.080000</td>\n",
       "      <td>4.400000</td>\n",
       "      <td>8.160000</td>\n",
       "      <td>5.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>已婚</th>\n",
       "      <td>24.617347</td>\n",
       "      <td>5.158163</td>\n",
       "      <td>4.678571</td>\n",
       "      <td>6.943878</td>\n",
       "      <td>6.806122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>未结过婚</th>\n",
       "      <td>26.600000</td>\n",
       "      <td>6.800000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>10.600000</td>\n",
       "      <td>8.800000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>离婚</th>\n",
       "      <td>23.466667</td>\n",
       "      <td>4.333333</td>\n",
       "      <td>4.600000</td>\n",
       "      <td>6.600000</td>\n",
       "      <td>6.866667</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   总分      PA总分      NA总分       PE总分      NE总分\n",
       "                   均值        均值        均值         均值        均值\n",
       "4、您的婚姻状况是：                                                    \n",
       "丧偶          28.040000  6.080000  4.400000   8.160000  5.800000\n",
       "已婚          24.617347  5.158163  4.678571   6.943878  6.806122\n",
       "未结过婚        26.600000  6.800000  6.000000  10.600000  8.800000\n",
       "离婚          23.466667  4.333333  4.600000   6.600000  6.866667"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>总分</th>\n",
       "      <th>PA总分</th>\n",
       "      <th>NA总分</th>\n",
       "      <th>PE总分</th>\n",
       "      <th>NE总分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5、您的居住方式是：</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>住在养老院</th>\n",
       "      <td>24.189189</td>\n",
       "      <td>4.972973</td>\n",
       "      <td>4.972973</td>\n",
       "      <td>6.540541</td>\n",
       "      <td>6.351351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>和子女居住在一起</th>\n",
       "      <td>24.903846</td>\n",
       "      <td>5.192308</td>\n",
       "      <td>4.519231</td>\n",
       "      <td>7.365385</td>\n",
       "      <td>7.134615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>和配偶居住在一起</th>\n",
       "      <td>24.715789</td>\n",
       "      <td>5.200000</td>\n",
       "      <td>4.642105</td>\n",
       "      <td>7.010526</td>\n",
       "      <td>6.852632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>独自一个人居住</th>\n",
       "      <td>25.842105</td>\n",
       "      <td>5.508772</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>7.473684</td>\n",
       "      <td>6.473684</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   总分      PA总分      NA总分      PE总分      NE总分\n",
       "                   均值        均值        均值        均值        均值\n",
       "5、您的居住方式是：                                                   \n",
       "住在养老院       24.189189  4.972973  4.972973  6.540541  6.351351\n",
       "和子女居住在一起    24.903846  5.192308  4.519231  7.365385  7.134615\n",
       "和配偶居住在一起    24.715789  5.200000  4.642105  7.010526  6.852632\n",
       "独自一个人居住     25.842105  5.508772  4.666667  7.473684  6.473684"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>总分</th>\n",
       "      <th>PA总分</th>\n",
       "      <th>NA总分</th>\n",
       "      <th>PE总分</th>\n",
       "      <th>NE总分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6、您的文化程度是：</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>中专或技校</th>\n",
       "      <td>24.032258</td>\n",
       "      <td>5.096774</td>\n",
       "      <td>5.161290</td>\n",
       "      <td>6.967742</td>\n",
       "      <td>6.870968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>初中</th>\n",
       "      <td>23.416667</td>\n",
       "      <td>5.027778</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>6.833333</td>\n",
       "      <td>7.444444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>大专或者本科</th>\n",
       "      <td>29.250000</td>\n",
       "      <td>6.250000</td>\n",
       "      <td>4.250000</td>\n",
       "      <td>9.187500</td>\n",
       "      <td>5.937500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>小学</th>\n",
       "      <td>25.660714</td>\n",
       "      <td>5.375000</td>\n",
       "      <td>4.750000</td>\n",
       "      <td>7.785714</td>\n",
       "      <td>6.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>文盲</th>\n",
       "      <td>24.755102</td>\n",
       "      <td>5.306122</td>\n",
       "      <td>4.285714</td>\n",
       "      <td>5.959184</td>\n",
       "      <td>6.224490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>硕士研究生及以上学历</th>\n",
       "      <td>23.814815</td>\n",
       "      <td>4.888889</td>\n",
       "      <td>4.666667</td>\n",
       "      <td>6.962963</td>\n",
       "      <td>7.370370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高中</th>\n",
       "      <td>25.461538</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>4.461538</td>\n",
       "      <td>7.384615</td>\n",
       "      <td>6.461538</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   总分      PA总分      NA总分      PE总分      NE总分\n",
       "                   均值        均值        均值        均值        均值\n",
       "6、您的文化程度是：                                                   \n",
       "中专或技校       24.032258  5.096774  5.161290  6.967742  6.870968\n",
       "初中          23.416667  5.027778  5.000000  6.833333  7.444444\n",
       "大专或者本科      29.250000  6.250000  4.250000  9.187500  5.937500\n",
       "小学          25.660714  5.375000  4.750000  7.785714  6.750000\n",
       "文盲          24.755102  5.306122  4.285714  5.959184  6.224490\n",
       "硕士研究生及以上学历  23.814815  4.888889  4.666667  6.962963  7.370370\n",
       "高中          25.461538  5.000000  4.461538  7.384615  6.461538"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>总分</th>\n",
       "      <th>PA总分</th>\n",
       "      <th>NA总分</th>\n",
       "      <th>PE总分</th>\n",
       "      <th>NE总分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7、您现在的每个月收入（不包括子女给的）：</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1000-2500元</th>\n",
       "      <td>26.457627</td>\n",
       "      <td>5.288136</td>\n",
       "      <td>3.932203</td>\n",
       "      <td>7.559322</td>\n",
       "      <td>6.457627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10000元以上</th>\n",
       "      <td>26.090909</td>\n",
       "      <td>5.772727</td>\n",
       "      <td>3.954545</td>\n",
       "      <td>7.681818</td>\n",
       "      <td>7.409091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1000元以下</th>\n",
       "      <td>24.853659</td>\n",
       "      <td>5.073171</td>\n",
       "      <td>4.585366</td>\n",
       "      <td>6.975610</td>\n",
       "      <td>6.609756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2500-4000元</th>\n",
       "      <td>23.264706</td>\n",
       "      <td>4.882353</td>\n",
       "      <td>5.323529</td>\n",
       "      <td>6.558824</td>\n",
       "      <td>6.852941</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4000-5500元</th>\n",
       "      <td>24.333333</td>\n",
       "      <td>5.055556</td>\n",
       "      <td>4.944444</td>\n",
       "      <td>6.888889</td>\n",
       "      <td>6.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5500-7000元</th>\n",
       "      <td>25.045455</td>\n",
       "      <td>5.363636</td>\n",
       "      <td>4.681818</td>\n",
       "      <td>6.727273</td>\n",
       "      <td>6.363636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7000-8500元</th>\n",
       "      <td>23.423077</td>\n",
       "      <td>5.153846</td>\n",
       "      <td>5.500000</td>\n",
       "      <td>7.153846</td>\n",
       "      <td>7.384615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8500-10000元</th>\n",
       "      <td>24.631579</td>\n",
       "      <td>5.578947</td>\n",
       "      <td>5.421053</td>\n",
       "      <td>7.105263</td>\n",
       "      <td>6.631579</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                              总分      PA总分      NA总分      PE总分      NE总分\n",
       "                              均值        均值        均值        均值        均值\n",
       "7、您现在的每个月收入（不包括子女给的）：                                                   \n",
       "1000-2500元             26.457627  5.288136  3.932203  7.559322  6.457627\n",
       "10000元以上               26.090909  5.772727  3.954545  7.681818  7.409091\n",
       "1000元以下                24.853659  5.073171  4.585366  6.975610  6.609756\n",
       "2500-4000元             23.264706  4.882353  5.323529  6.558824  6.852941\n",
       "4000-5500元             24.333333  5.055556  4.944444  6.888889  6.666667\n",
       "5500-7000元             25.045455  5.363636  4.681818  6.727273  6.363636\n",
       "7000-8500元             23.423077  5.153846  5.500000  7.153846  7.384615\n",
       "8500-10000元            24.631579  5.578947  5.421053  7.105263  6.631579"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>总分</th>\n",
       "      <th>PA总分</th>\n",
       "      <th>NA总分</th>\n",
       "      <th>PE总分</th>\n",
       "      <th>NE总分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9、您和孩子之间的关系：</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>关系一般</th>\n",
       "      <td>23.784615</td>\n",
       "      <td>4.953846</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>6.923077</td>\n",
       "      <td>7.092308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>关系较差</th>\n",
       "      <td>23.280000</td>\n",
       "      <td>4.840000</td>\n",
       "      <td>4.960000</td>\n",
       "      <td>7.240000</td>\n",
       "      <td>7.840000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>很亲近</th>\n",
       "      <td>27.049180</td>\n",
       "      <td>5.622951</td>\n",
       "      <td>4.114754</td>\n",
       "      <td>7.393443</td>\n",
       "      <td>5.852459</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>比较亲近</th>\n",
       "      <td>24.811111</td>\n",
       "      <td>5.288889</td>\n",
       "      <td>4.733333</td>\n",
       "      <td>7.055556</td>\n",
       "      <td>6.800000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     总分      PA总分      NA总分      PE总分      NE总分\n",
       "                     均值        均值        均值        均值        均值\n",
       "9、您和孩子之间的关系：                                                   \n",
       "关系一般          23.784615  4.953846  5.000000  6.923077  7.092308\n",
       "关系较差          23.280000  4.840000  4.960000  7.240000  7.840000\n",
       "很亲近           27.049180  5.622951  4.114754  7.393443  5.852459\n",
       "比较亲近          24.811111  5.288889  4.733333  7.055556  6.800000"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>总分</th>\n",
       "      <th>PA总分</th>\n",
       "      <th>NA总分</th>\n",
       "      <th>PE总分</th>\n",
       "      <th>NE总分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10、您目前的身体状况：</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>一般</th>\n",
       "      <td>24.588235</td>\n",
       "      <td>4.985294</td>\n",
       "      <td>4.852941</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>6.544118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>比较健康</th>\n",
       "      <td>24.468354</td>\n",
       "      <td>5.189873</td>\n",
       "      <td>4.721519</td>\n",
       "      <td>7.012658</td>\n",
       "      <td>7.012658</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>身体不好</th>\n",
       "      <td>23.000000</td>\n",
       "      <td>5.028571</td>\n",
       "      <td>5.085714</td>\n",
       "      <td>6.657143</td>\n",
       "      <td>7.600000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>非常健康</th>\n",
       "      <td>27.135593</td>\n",
       "      <td>5.711864</td>\n",
       "      <td>4.152542</td>\n",
       "      <td>7.694915</td>\n",
       "      <td>6.118644</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     总分      PA总分      NA总分      PE总分      NE总分\n",
       "                     均值        均值        均值        均值        均值\n",
       "10、您目前的身体状况：                                                   \n",
       "一般            24.588235  4.985294  4.852941  7.000000  6.544118\n",
       "比较健康          24.468354  5.189873  4.721519  7.012658  7.012658\n",
       "身体不好          23.000000  5.028571  5.085714  6.657143  7.600000\n",
       "非常健康          27.135593  5.711864  4.152542  7.694915  6.118644"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>总分</th>\n",
       "      <th>PA总分</th>\n",
       "      <th>NA总分</th>\n",
       "      <th>PE总分</th>\n",
       "      <th>NE总分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11、您是否经常和朋友一起进行娱乐活动</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>从不</th>\n",
       "      <td>24.409091</td>\n",
       "      <td>5.060606</td>\n",
       "      <td>4.863636</td>\n",
       "      <td>7.121212</td>\n",
       "      <td>6.909091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>偶尔</th>\n",
       "      <td>25.093458</td>\n",
       "      <td>5.158879</td>\n",
       "      <td>4.495327</td>\n",
       "      <td>6.953271</td>\n",
       "      <td>6.523364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>经常</th>\n",
       "      <td>25.220588</td>\n",
       "      <td>5.529412</td>\n",
       "      <td>4.764706</td>\n",
       "      <td>7.397059</td>\n",
       "      <td>6.941176</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            总分      PA总分      NA总分      PE总分      NE总分\n",
       "                            均值        均值        均值        均值        均值\n",
       "11、您是否经常和朋友一起进行娱乐活动                                                   \n",
       "从不                   24.409091  5.060606  4.863636  7.121212  6.909091\n",
       "偶尔                   25.093458  5.158879  4.495327  6.953271  6.523364\n",
       "经常                   25.220588  5.529412  4.764706  7.397059  6.941176"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>总分</th>\n",
       "      <th>PA总分</th>\n",
       "      <th>NA总分</th>\n",
       "      <th>PE总分</th>\n",
       "      <th>NE总分</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "      <th>均值</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13、您是否有自己的兴趣爱好</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>否</th>\n",
       "      <td>23.477612</td>\n",
       "      <td>5.014925</td>\n",
       "      <td>5.022388</td>\n",
       "      <td>6.925373</td>\n",
       "      <td>7.440299</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>是</th>\n",
       "      <td>26.775701</td>\n",
       "      <td>5.514019</td>\n",
       "      <td>4.233645</td>\n",
       "      <td>7.373832</td>\n",
       "      <td>5.878505</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       总分      PA总分      NA总分      PE总分      NE总分\n",
       "                       均值        均值        均值        均值        均值\n",
       "13、您是否有自己的兴趣爱好                                                   \n",
       "否               23.477612  5.014925  5.022388  6.925373  7.440299\n",
       "是               26.775701  5.514019  4.233645  7.373832  5.878505"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(性别)\n",
    "display(年龄)\n",
    "display(居住地)\n",
    "display(婚姻)\n",
    "display(居住方式)\n",
    "display(文化)\n",
    "display(收入)\n",
    "display(子女关系)\n",
    "display(身体)\n",
    "display(娱乐)\n",
    "display(兴趣)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x19f90452790>"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW4AAAEGCAYAAABFBX+4AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAARFklEQVR4nO3dfazddX3A8fent4+UCoVeWFgDFxNUcFAeKg+zrLC0gEhd0QWa6DanQEzIHoIJApIFJcsMDDQjkQxlkxWrA40MERgPWVlVDL2lttZNN9wKXkrHLRSKFdrb28/++P1KD9dL7+3pOT33e/t+JTc9D79z7ueS2ze/fn/n/E5kJpKkckzo9ACSpL1juCWpMIZbkgpjuCWpMIZbkgpjuCWpMBPb/Q1mzZqVPT097f42kjSurFq1alNmdg93X9vD3dPTQ29vb7u/jSSNKxHx7Nvd51KJJBXGcEtSYQy3JBXGcEtSYQy3JBXGcEtSYQy3JBXGcEtSYUZ8A05EHAJ8E+gCtgKXAs8A/1Nv8meZ+ZO2Tbif9FzzvU6PMK6s/8IHOz2CNG6NZo/7o8CtmXkesBG4BvhGZp5TfxUfbUkqyYjhzswvZ+aj9dVuYAdwUUQ8FRF3RkTb3zYvSdpt1GvcEXEWMBN4FFiQmacDk4ALh9n2iojojYje/v7+lg0rSRpluCPiMOA24BPA2sx8ob6rFzhu6PaZeUdmzs3Mud3dw57cSpLUpBHDHRGTgXuBazPzWWBpRMyJiC5gMbCmzTNKkhqMZo/7k8CpwGcjYjnwU2Ap8GPgycx8rH3jSZKGGvHAYmbeDtw+5ObPtWccSUP5UtXWGg8vVfUNOJJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUmBHDHRGHRMRDEfFIRHwnIiZHxJ0R8WREXL8/hpQk7TaaPe6PArdm5nnARmAJ0JWZZwHvjIjj2jmgJOmtJo60QWZ+ueFqN/Ax4Ev19UeAecB/t340SdJwRr3GHRFnATOBXwLP1ze/DBw5zLZXRERvRPT29/e3ZFBJUmVU4Y6Iw4DbgE8AvwKm1XcdPNxzZOYdmTk3M+d2d3e3alZJEqM7ODkZuBe4NjOfBVZRLY8AzAHWt206SdJvGM0e9yeBU4HPRsRyIIA/iohbgUuA77VvPEnSUKM5OHk7cHvjbRFxP7AQuCkzX23TbJKkYYwY7uFk5mbgnhbPIkkaBd85KUmFMdySVBjDLUmFMdySVBjDLUmFMdySVBjDLUmFMdySVBjDLUmFMdySVBjDLUmFMdySVBjDLUmFMdySVBjDLUmFMdySVBjDLUmFMdySVBjDLUmFMdySVBjDLUmFMdySVBjDLUmFMdySVBjDLUmFMdySVBjDLUmFMdySVBjDLUmFMdySVBjDLUmFMdySVJhRhTsijoyIFfXliRHxXEQsr79ObO+IkqRGE0faICJmAncB0+ubTgK+kZmfaedgkqThjWaPexC4FNhSXz8TuCginoqIOyNixPhLklpnxHBn5pbMfLXhppXAgsw8HZgEXDj0MRFxRUT0RkRvf39/66aVJDV1cHJtZr5QX+4Fjhu6QWbekZlzM3Nud3f3Pg0oSXqrZsK9NCLmREQXsBhY0+KZJEl70Mz69OeBZUAA92fmY60dSZK0J6MOd2aeU/+5juqVJZKkDvANOJJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUGMMtSYUx3JJUmFGFOyKOjIgVDdfvjIgnI+L69o0mSRrOiOGOiJnAXcD0+vqHga7MPAt4Z0Qc194RJUmNRrPHPQhcCmypr58D3FNffgSY1/qxJElvZ8RwZ+aWzHy14abpwPP15ZeBI4c+JiKuiIjeiOjt7+9vzaSSJKC5g5O/AqbVlw8e7jky847MnJuZc7u7u/dlPknSEM2EexW7l0fmAOtbNo0kaUQTm3jMfcCKiDgK+ABwZmtHkiTtyaj3uDPznPrPLVQHKH8EnDtk/VuS1GbN7HGTmZvZ/coSSdJ+5DsnJakwhluSCmO4JakwhluSCmO4JakwhluSCmO4JakwhluSCmO4JakwhluSCmO4JakwhluSCmO4JakwhluSCmO4JakwhluSCmO4JakwhluSCmO4JakwhluSCmO4JakwhluSCmO4JakwhluSCmO4JakwhluSCmO4JakwhluSCmO4JakwhluSCmO4Jakwex3uiJgYEc9FxPL668R2DCZJGt7EJh5zEvCNzPxMq4eRJI2smaWSM4GLIuKpiLgzIpqJvySpSc2EeyWwIDNPByYBF7Z2JEnSnjQT7rWZ+UJ9uRc4bugGEXFFRPRGRG9/f/8+DShJeqtmwr00IuZERBewGFgzdIPMvCMz52bm3O7u7n0eUpK0WzPr058HlgEB3J+Zj7V2JEnSnux1uDNzHdUrSyRJHeAbcCSpMIZbkgpjuCWpMIZbkgpjuCWpMIZbkgpjuCWpMIZbkgpjuCWpMIZbkgpjuCWpMIZbkgpjuCWpMIZbkgrj50VqTBkYGKCvr4833nij06O03NSpU5k9ezaTJk3q9CgqnOHWmNLX18eMGTPo6ekhIjo9TstkJi+99BJ9fX0ce+yxnR5HhXOpRGPKG2+8weGHHz6uog0QERx++OHj8l8S2v8Mt8ac8RbtXcbrz6X9z3BLI9i6deuwtzfuPQ8MDDAwMLC/RtIBzjVujWk913yvpc+3/gsfHHGb1157jfPPP58f/vCHAFxyySXcfPPNnHDCCW/ZbvHixVx77bUcc8wxPPLII6xYsYIbb7yRwcFBjjnmGCZO9K+X2sPfLGmISZMmMXnyZKDa2169ejXLli178/7LL7+cHTt2MGXKFLZt28a9997LypUr2bZtG9/61rfYsWMHV155JTNmzOjUj6BxzqUSqcHDDz/Mueeey+rVq5k/fz533303V111FZdddhmXXXYZzz77LBs3buS6667j+OOPZ8GCBTz44IOsXr2an/3sZzzwwAO8733vM9pqK8MtNVi4cCGPP/44p5xyCg899BBf+cpXOPTQQ1m3bh09PT1MmTKFhx9+mDVr1gAwYcIEtm7dytKlS7nrrrs4++yz2bx5c4d/Co13LpVIDbq6upgwodqfOeigg3j00UeZNm0aV199NfPnz2dgYICLL76YM844g+XLlwPw+uuv88wzzwDw4osvdmp0HUAMt/Q2tm/fzsyZM9m5cydHHHEEt9xyy5u3bd++/c3tXnjhBb761a8CsHHjRhYuXNipkXWAcKlEatDX18eyZctYu3YtS5YsYd26dcyfP5/Zs2dzww03MDAwwNSpU9/ymFmzZrF48WIWL17Mqaee2qHJdSBxj1tj2mhevtdKq1evZsOGDaxdu5bZs2fz3HPPcdttt3HyySeTmfT39zN9+nQyk507dzI4OMghhxzCvHnzAHjllVcAGBwcpKura7/OrgOH4ZYaLFq0iEWLFr15/eijj+boo49m1apVLFq0iAsuuICDDjqIbdu2sWnTJi688EK6u7u54YYb3nzMypUr2bFjB0uWLOnAT6ADgeGWRuG0005jw4YNb16fN2/em3vZ0v7mGrfGnMzs9AhtMV5/Lu1/hltjytSpU3nppZfGXeR2ndZ16IFNqRkulWhMmT17Nn19ffT393d6lJbb9UEK0r4y3BpTJk2a5AcNSCNwqUSSCtN0uCPizoh4MiKub+VAkqQ9ayrcEfFhoCszzwLeGRHHtXYsSdLbiWaO3kfE3wEPZ+aDEbEEmJaZ/9hw/xXAFfXVdwM/b8WwAmAWsKnTQ0jD8HeztY7JzO7h7mj24OR04Pn68svAW07QkJl3AHc0+dzag4jozcy5nZ5DGsrfzf2n2TXuXwHT6ssH78PzSJL2UrPBXQXser/vHGB9S6aRJI2o2aWS+4AVEXEU8AHgzNaNpBG4BKWxyt/N/aSpg5MAETETWAj8e2ZubOlUkqS31XS4JUmd4UFFSSqM4ZakwhjuAkTEWcPcNrkTs0jqPNe4CxARj2XmgiG3/S3Qm5nf7NBYOoBFxJeBHfXVCcBtwK3A0cAG4O7MXNqh8cY997jL0BURl0dEN0D9Msx5wD93diwdwE4Hvg38LrAOmE116osTgU8An44ITxvdJv6HLcNO4FDgnoj4BTAFuCH955I65+XMfCIiNgNPAzN23ZGZz0fEXwCDHZtunHOPuwyDmXlzZp4L/AuwBHi2wzPpwHZsRFwH9AAfB7qBSbvuzMwn3LFoH8M9RkXEORHxeER8FGj8oMJ3AZ8FvtiZySQAtlGdaG4b1RkB/xQ4OSJ+EBEf6ehkBwDDPXY9Afwl1cGe90TEAxFxAbAIuAVYExHv7+SAOqBtyMy7gBeAB4CbgJXARcBlEXFuJ4cb7wz3GJWVn2Tm3wBrgE9RHZD8bmYOAt8B/qCTM+qAdlhE/B4wk4bTOmfmZqpz8f95pwY7EBjuMkzMzL7MvD4zb6lvexpwDVGdshK4GFgBnEC1bDIxIiZk5i+BWRExaU9PoOb5Ou4CRMQpmbm603NIexIR78jMLfXl2ZnZ1+mZxivDLUmFcalEkgpjuFW0iDi4/nNCROzT73NEdEXEjJG3lDrLcKtYERHAtyPivVSvZLh6D9v+dUQcW1+eHBHfHmazY6k/xSUijoqId0TEYxHxjiHP9UREfL/+eqXxIFz9Omb/Xqmt/AVTx0XEkRGxoomHXg38HNgCXAtcFBHL66+n609p2uU0dr/bdCHw64h4T/2160yLb9TzHEX1crY59W3bh3zfHZk5LzPnUZ3oayAilkbEu4CBzNzZxM8ijZrnKlFH1XG9C5i+l4/7Q+D3gdVUZ6b7CPALqhMc/T3w6czcHBFdVO/sWwM8HRHfBU6hiv01VCdL+nA9x4eozrlxE3AYVeznAPdHxHTg3MzcTnXSr+vrUXrq77GN3wy81BbucavTBoFLqUK6Nx6keus/VNH+K6oz1J0IXAX8H0D9ZqWnM/Mcqneivpvq3X6fysyPA/9GFd331I/ZBDwFdGXmwvryhzLz/XW0Aa4EDqHaG/8Yvp5e+5nhVkdl5pbMfLWJx/0aiPrrJmBpfTmBG4HT6yUPgDkRsRz4EvAfwBeAu+v7pgBbqfaWV9W33Q98sV5DB3Z/cEVEHA98EDie6o0n84D5w80YET0RkRHxO3v780l7Yrg15kTEaRHx7lFsugX4CfA54AfA5cDXqJZdLs/MDfV2P27Y4yYzfwEMRsRJwDRga2Z+Hfjf+v71wG8B/0q1lHI/cF/9XJupAp/A94HXgPPZ/T+RRs9TBf6/Rv3DS6NguDUWbQP+oXGP9218gGp543PAAqpgr6DaI759hMdeCfyUKty/HnpnZn4tM89j91LJhfXtG4HlVGH/ev0crwPPsPsTYaS2MtwaczJzHdWe7R+/3Tb1wcQlVK8qmZmZ/0T1iSxHUoV0U8MZ6k5pWCrZ9T021OvfhzecNzqqp46oDzg2fr8J9dcU4E7gHqqD++8FttQnA3sROLjhYb8N/CfVqXillvFVJRoT6qWMRlcBL+3hIbOoDkhuAs6IiEeoDnQeAdycmddB9aYaYFVmnld/6PLZ9e1/AlwP/KjhOafUXycBt0TErj3o+6h2cm6h+iSi9Zl5c0ScR/XRXdc1bPdYw8+0nt9cPpH2mecq0bgQEbE3n7hS77FPzMz+No4ltYXhlqTCuMYtSYUx3JJUGMMtSYUx3JJUGMMtSYX5fyVFT4bITDYjAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "性别.reset_index().plot.bar(x = '1、您的性别：',y = \"总分\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}
